package com.vcar.LDiceServer.db;

public class SQLs
{
	// public static final String get_user
	// ="select userid,nickname,power,physical,speed,intelligence from users where userid=? and pwd=? ";
	// public static final String get_user_byid2
	// ="select count(*) from users where userid=?";
	// public static final String get_user_byid
	// ="select userid,level,nickname,experience,power,physical,speed,intelligence from users where userid=?";
	// public static final String get_user_bynick
	// ="select count(*) from users where nickname=?";
	// public static final String
	// get_user_on_props="select propid,propsname,power,physical,speed,intelligence,pos from user_props where userid=? and status=1";
	// public static final String
	// get_user_off_props="select propid,propsname,power,physical,speed,intelligence,pos from user_props where userid=? and status=2 order by pos";
	// public static final String
	// get_user_on_skill="select skillid,skillname,level,pos2 from user_skill where userid=? and status=1 order by pos2";
	// public static final String
	// get_user_skill="select skillid,skillname,level,pos1 from user_skill where userid=? order by pos1";
	// public static final String
	// get_userprops_byid="select propid,propsname,pos,status,power,physical,speed,intelligence from user_props where propid=?";
	// public static final String
	// get_userprops_byposstatus="select propid,propsname,pos,status,power,physical,speed,intelligence from user_props where status=? and pos =?";
	// public static final String
	// get_userskill_byid="select skillid,skillname,level,status,pos1,pos2 from user_skill where skillid=?";
	// public static final String move_userprops =
	// "update user_props set status =? , pos=? where userid=? and propid=?";
	// public static final String del_userprops_byid =
	// "delete from user_props where userid=? and propid=?";
	// public static final String move_down_userskill
	// ="update user_skill set status=2,pos2=0 where userid=? and pos2=?";
	// public static final String move_down_allskill =
	// "update user_skill set status=2,pos2=0 where userid=?";
	// public static final String move_up_userskill
	// ="update user_skill set status =1 , pos2=? where userid =? and skillid=?";
	// public static final String add_user
	// ="insert into users(userid,pwd,nickname,level,power,physical,speed,intelligence) values(?,?,?,1,20,25,30,35)";
	// public static final String
	// add_user_skill="insert into user_skill(userid,skillid,skillname,level,status,pos1) values(?,?,?,1,2,?)";
	// public static final String
	// add_user_props="insert into user_props(userid,propid,propsname,power,physical,speed,intelligence,type,status,pos) values(?,?,?,?,?,?,?,?,2,?)";
	public static final String User_Login = "select * from usertable where userid=?";
	public static final String Role_Get = "select * from avatar where avatarid=?";
	// public static final String UserName_Select =
	// "select userid,pwd from usertable where userid=?";
}
